if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_NhomHang_Insert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_NhomHang_Insert]
GO
CREATE PROC [sp_NhomHang_Insert]
	@ten			nvarchar(100),
	@maNganhHang		int,
	@thue			float,
	@ChietKhau		float,
	@ghiChu			nvarchar(500)
AS
BEGIN
	INSERT INTO NhomHang(Ten, Ma_nganh_hang, Thue,Chiet_Khau, Ghi_chu)
		VALUES(
			@ten,
			@maNganhHang,
			@thue,
			@ChietKhau,
			@ghiChu
		)
END